import  pandas as pd
data = pd.read_csv('python爬虫招聘信息3.csv')
data['公司地址'] = data['公司地址'].map(lambda x: str(x).split('·')[0])+'市'
index = data[data['工资'].map(lambda x: str(x).find('元/天')) != -1].index
data = data.drop(index=index)
index = data[data['工资'].map(lambda x: str(x).find('元/时')) != -1].index
data = data.drop(index=index)
ks = data['工资'].map(lambda x: str(x).split('-')[1])
data['工资'] = ks.map(lambda x: str(x).split('K')[0])

data.to_csv('招聘信息.csv',index=False)